package com.gzdh.tang.config.weixin;

import java.io.Serializable;
import java.util.ArrayList;
import java.util.List;


public class Bill implements Serializable{
	private String date;//﻿交易时间
    private String appId;//公众账号ID
    private String mch_id;//商户号
    private String subMch_id;//子商户号 特约商户号
    private String device_info;//设备号
    private String weiXinOrderNo;//微信订单号
    private String mchOrderNo;//商户订单号
    private String userId;//用户标识
    private String type;//交易类型
    private String status;//交易状态
    private String bank;//付款银行
    private String currency;//货币种类
    
    
    private String yPrice;//应结金额
    private String reWeixinOrderInfo;//微信退款单号
    private String remchOrder;//商户退款单号
    private String rePrice;//退款金额
    private String reType;//退款类型-->ORIGINAL原路腿狂
    private String reStatus;//退款状态
    
    
    private String amount;//总金额
    private String envelopeAmount;//企业红包金额 代金券金额
    private String name;//商品名称
    private String packet;//商户数据包
    private String poundage;//手续费
    private String rate;//费率
    private String orderAmount; //订单金额
 
    public String getOrderAmount() {
        return orderAmount;
    }
 
    public void setOrderAmount(String orderAmount) {
        this.orderAmount = orderAmount;
    }
 
    public String getDate() {
        return date;
    }
 
    public void setDate(String date) {
        this.date = date;
    }
 
    public String getAppId() {
        return appId;
    }
 
    public void setAppId(String appId) {
        this.appId = appId;
    }
 
    public String getMch_id() {
        return mch_id;
    }
 
    public void setMch_id(String mch_id) {
        this.mch_id = mch_id;
    }
 
    public String getSubMch_id() {
        return subMch_id;
    }
 
    public void setSubMch_id(String subMch_id) {
        this.subMch_id = subMch_id;
    }
 
    public String getDevice_info() {
        return device_info;
    }
 
    public void setDevice_info(String device_info) {
        this.device_info = device_info;
    }
 
    public String getWeiXinOrderNo() {
        return weiXinOrderNo;
    }
 
    public void setWeiXinOrderNo(String weiXinOrderNo) {
        this.weiXinOrderNo = weiXinOrderNo;
    }
 
    public String getMchOrderNo() {
        return mchOrderNo;
    }
 
    public void setMchOrderNo(String mchOrderNo) {
        this.mchOrderNo = mchOrderNo;
    }
 
    public String getUserId() {
        return userId;
    }
 
    public void setUserId(String userId) {
        this.userId = userId;
    }
 
    public String getType() {
        return type;
    }
 
    public void setType(String type) {
        this.type = type;
    }
 
    public String getStatus() {
        return status;
    }
 
    public void setStatus(String status) {
        this.status = status;
    }
 
    public String getBank() {
        return bank;
    }
 
    public void setBank(String bank) {
        this.bank = bank;
    }
 
    public String getCurrency() {
        return currency;
    }
 
    public void setCurrency(String currency) {
        this.currency = currency;
    }
 
    public String getAmount() {
        return amount;
    }
 
    public void setAmount(String amount) {
        this.amount = amount;
    }
 
    public String getEnvelopeAmount() {
        return envelopeAmount;
    }
 
    public void setEnvelopeAmount(String envelopeAmount) {
        this.envelopeAmount = envelopeAmount;
    }
 
    public String getName() {
        return name;
    }
 
    public void setName(String name) {
        this.name = name;
    }
 
    public String getPacket() {
        return packet;
    }
 
    public void setPacket(String packet) {
        this.packet = packet;
    }
 
    public String getPoundage() {
        return poundage;
    }
 
    public void setPoundage(String poundage) {
        this.poundage = poundage;
    }
 
    public String getRate() {
        return rate;
    }
 
    public void setRate(String rate) {
        this.rate = rate;
    }
   
    public String getReWeixinOrderInfo() {
		return reWeixinOrderInfo;
	}

	public void setReWeixinOrderInfo(String reWeixinOrderInfo) {
		this.reWeixinOrderInfo = reWeixinOrderInfo;
	}

	public String getRemchOrder() {
		return remchOrder;
	}

	public void setRemchOrder(String remchOrder) {
		this.remchOrder = remchOrder;
	}

	public String getRePrice() {
		return rePrice;
	}

	public void setRePrice(String rePrice) {
		this.rePrice = rePrice;
	}

	public String getReType() {
		return reType;
	}

	public void setReType(String reType) {
		this.reType = reType;
	}

	public String getReStatus() {
		return reStatus;
	}

	public void setReStatus(String reStatus) {
		this.reStatus = reStatus;
	}
	

	public String getyPrice() {
		return yPrice;
	}

	public void setyPrice(String yPrice) {
		this.yPrice = yPrice;
	}

	//date 为账单时间 格式 2018-12-25
    //result  接口返回数据
    public static List<Bill> analyze(String result ,String date){
        List<Bill> bills = new ArrayList<Bill>();
        String tradeMsg = result.substring(result.indexOf("`")); //去标题
        String tradeInfo = tradeMsg.substring(0, tradeMsg.indexOf("总")).replaceFirst(date,"").replaceAll("`","");;// 去掉汇总数据
        String[] tradeArray = tradeInfo.split(date); //通过交易时间分隔   订单数
        for(String trade : tradeArray){
            String[] order = trade.split(",");
            Bill bill = new Bill();
            bill.setDate(date+order[0]);
            bill.setAppId(order[1]);
            bill.setMch_id(order[2]);
            bill.setSubMch_id(order[3]);
            bill.setDevice_info(order[4]);
            bill.setWeiXinOrderNo(order[5]);
            bill.setMchOrderNo(order[6]);
            bill.setUserId(order[7]);
            bill.setType(order[8]);
            bill.setStatus(order[9]);
            bill.setBank(order[10]);
            bill.setCurrency(order[11]);
            bill.setyPrice(order[12]);
            bill.setAmount(order[12]);
            bill.setReWeixinOrderInfo(order[14]);
            bill.setRemchOrder(order[15]);
            bill.setRePrice(order[16]);
            bill.setReType(order[18]);
            bill.setReStatus(order[19]);
            bill.setEnvelopeAmount("0");//企业红包
            bill.setName(order[20]);
            bill.setPacket(order[21]);
            bill.setPoundage(order[22]);
            bill.setRate(order[23]);
            bill.setOrderAmount(order[24]);
            bills.add(bill);
        }
        return bills;
    }
 
    
    
    @Override
	public String toString() {
		return "Bill [date=" + date + ", appId=" + appId + ", mch_id=" + mch_id + ", subMch_id=" + subMch_id
				+ ", device_info=" + device_info + ", weiXinOrderNo=" + weiXinOrderNo + ", mchOrderNo=" + mchOrderNo
				+ ", userId=" + userId + ", type=" + type + ", status=" + status + ", bank=" + bank + ", currency="
				+ currency + ", amount=" + amount + ", envelopeAmount=" + envelopeAmount + ", name=" + name
				+ ", packet=" + packet + ", poundage=" + poundage + ", rate=" + rate + ", orderAmount=" + orderAmount
				+ "]";
	}

	public static void main(String[] args) {
        String result = "?交易时间,公众账号ID,商户号,特约商户号,设备号,微信订单号,商户订单号,用户标识,交易类型,交易状态,付款银行,货币种类,应结订单金额,代金券金额,微信退款单号,商户退款单号,退款金额,充值券退款金额,退款类型,退款状态,商品名称,商户数据包,手续费,费率,订单金额,申请退款金额,费率备注\r\n" + 
        		"`2019-08-31 16:37:43,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000340201908318172651747,`wxzf1567240654671100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.04,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.04元,`2255,`0.00000,`0.60%,`0.04,`0.00,`\r\n" + 
        		"`2019-08-31 16:39:59,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000340201908318172651747,`wxzf1567240654671100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000301502019083111945164809,`wxtk156724079818056,`0.02,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.04元,`2255,`0.00000,`0.60%,`0.00,`0.02,`\r\n" + 
        		"`2019-08-31 18:10:27,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000341201908316531710640,`wxzf1567246160074100,`o8EPw08BsCvXGYy2X2SgXzl9HDe0,`JSAPI,`REFUND,`CFT,`CNY,`0.00,`0.00,`50000001522019083111964397291,`wxtk1567246226402619,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2218]在手机订餐系统上订餐\\ 金额0.03元,`2218,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 18:09:25,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000341201908316531710640,`wxzf1567246160074100,`o8EPw08BsCvXGYy2X2SgXzl9HDe0,`JSAPI,`SUCCESS,`CFT,`CNY,`0.03,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2218]在手机订餐系统上订餐\\ 金额0.03元,`2218,`0.00000,`0.60%,`0.03,`0.00,`\r\n" + 
        		"`2019-08-31 12:02:20,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000341201908319297250934,`wxzf1567224131872110,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.06,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.06元,`2498,`0.00000,`0.60%,`0.06,`0.00,`\r\n" + 
        		"`2019-08-31 12:04:21,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000341201908319297250934,`wxzf1567224131872110,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000601332019083111942440126,`wxtk1567224262009333,`0.06,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.06元,`2498,`0.00000,`0.60%,`0.00,`0.06,`\r\n" + 
        		"`2019-08-31 16:45:55,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000343201908317048518966,`wxzf1567241146857100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.02,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.02,`0.00,`\r\n" + 
        		"`2019-08-31 11:32:19,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000345201908316174298177,`wxzf1567220536657100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000101532019083111963598446,`wxtk156722233915814,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.04元,`2498,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 11:21:40,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000345201908316174298177,`wxzf1567220536657100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000101532019083111923414628,`wxtk1567221700077109,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.04元,`2498,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 11:02:25,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000345201908316174298177,`wxzf1567220536657100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.04,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.04元,`2498,`0.00000,`0.60%,`0.04,`0.00,`\r\n" + 
        		"`2019-08-31 17:06:06,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908310136082209,`wxzf1567241430636100,`o8EPw09RdvUxX1S8p299AxD1WG4o,`JSAPI,`REFUND,`CCB_DEBIT,`CNY,`0.00,`0.00,`50000101562019083111912964876,`wxtk1567241431965100,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2467]在手机订餐系统上订餐\\ 金额0.01元,`2467,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 16:50:36,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908310136082209,`wxzf1567241430636100,`o8EPw09RdvUxX1S8p299AxD1WG4o,`JSAPI,`SUCCESS,`CCB_DEBIT,`CNY,`0.01,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2467]在手机订餐系统上订餐\\ 金额0.01元,`2467,`0.00000,`0.60%,`0.01,`0.00,`\r\n" + 
        		"`2019-08-31 16:44:22,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908311096584715,`wxzf1567240992211100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000301352019083111964543655,`wxtk156724106133458,`0.02,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.05元,`2255,`0.00000,`0.60%,`0.00,`0.02,`\r\n" + 
        		"`2019-08-31 16:43:45,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908311096584715,`wxzf1567240992211100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000301352019083111944920694,`wxtk1567241024407326,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.05元,`2255,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 16:43:21,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908311096584715,`wxzf1567240992211100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.05,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.05元,`2255,`0.00000,`0.60%,`0.05,`0.00,`\r\n" + 
        		"`2019-08-31 15:20:29,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908312197224260,`wxzf1567235986360100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000401542019083111580881025,`wxtk1567236028484290,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 15:19:55,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908312197224260,`wxzf1567235986360100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.02,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.02,`0.00,`\r\n" + 
        		"`2019-08-31 15:24:32,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908312197224260,`wxzf1567235986360100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000401542019083111912956206,`wxtk1567236270989131,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 15:54:14,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908313911355569,`WXZF2019083115534588970000041,`o8EPw08BsCvXGYy2X2SgXzl9HDe0,`JSAPI,`REFUND,`CFT,`CNY,`0.00,`0.00,`50000101322019083111914255745,`WXTK20190831155356419700000410001,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[70000041]在手机订餐系统上订餐\\ 金额0.06元,`70000041,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 15:53:51,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908313911355569,`WXZF2019083115534588970000041,`o8EPw08BsCvXGYy2X2SgXzl9HDe0,`JSAPI,`SUCCESS,`CFT,`CNY,`0.06,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[70000041]在手机订餐系统上订餐\\ 金额0.06元,`70000041,`0.00000,`0.60%,`0.06,`0.00,`\r\n" + 
        		"`2019-08-31 16:51:18,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000346201908315680500749,`wxzf1567241469565100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.02,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.02,`0.00,`\r\n" + 
        		"`2019-08-31 15:28:55,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000349201908314195699676,`wxzf1567236526889100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.04,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.04元,`2255,`0.00000,`0.60%,`0.04,`0.00,`\r\n" + 
        		"`2019-08-31 15:29:15,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000349201908314195699676,`wxzf1567236526889100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000401432019083111965141731,`wxtk1567236554176637,`0.04,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.04元,`2255,`0.00000,`0.60%,`0.00,`0.04,`\r\n" + 
        		"`2019-08-31 15:22:21,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000349201908318689736194,`wxzf1567236075421100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000201472019083111913160226,`wxtk1567236140158362,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.05元,`2255,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 15:22:06,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000349201908318689736194,`wxzf1567236075421100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000201472019083111913415113,`wxtk1567236125399678,`0.02,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.05元,`2255,`0.00000,`0.60%,`0.00,`0.02,`\r\n" + 
        		"`2019-08-31 15:21:24,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000349201908318689736194,`wxzf1567236075421100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.05,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.05元,`2255,`0.00000,`0.60%,`0.05,`0.00,`\r\n" + 
        		"`2019-08-31 11:41:35,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000350201908319102839924,`wxzf1567222870358100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000401522019083111964068069,`wxtk1567222895564977,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 11:41:21,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000350201908319102839924,`wxzf1567222870358100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.03,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.03,`0.00,`\r\n" + 
        		"`2019-08-31 11:37:39,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000352201908312568052805,`wxzf1567222651174100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.03,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.03,`0.00,`\r\n" + 
        		"`2019-08-31 11:38:14,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000352201908312568052805,`wxzf1567222651174100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000501282019083111644293974,`wxtk1567222695122799,`0.02,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.00,`0.02,`\r\n" + 
        		"`2019-08-31 11:33:52,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000352201908316342900561,`wxzf1567214919541104,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000101362019083111856675136,`wxtk156722243244618,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.01元,`2498,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 09:28:48,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000352201908316342900561,`wxzf1567214919541104,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.01,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.01元,`2498,`0.00000,`0.60%,`0.01,`0.00,`\r\n" + 
        		"`2019-08-31 18:11:31,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000354201908312681056840,`wxzf1567246285247100,`o8EPw08BsCvXGYy2X2SgXzl9HDe0,`JSAPI,`SUCCESS,`CFT,`CNY,`0.04,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2218]在手机订餐系统上订餐\\ 金额0.04元,`2218,`0.00000,`0.60%,`0.04,`0.00,`\r\n" + 
        		"`2019-08-31 17:18:55,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000355201907245289843285,`WXZF201907241615353370000036,`o8EPw09RdvUxX1S8p299AxD1WG4o,`JSAPI,`REFUND,`CCB_DEBIT,`CNY,`0.00,`0.00,`50000501042019083111926644907,`WXZF201908311718353370000036,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[70000036]在手机订餐系统上订餐\\ 金额0.01元,`70000036,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 11:35:03,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000355201908310994175232,`wxzf1567222470138100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000001472019083111911134748,`wxtk1567222503280606,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.02元,`2498,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 11:34:41,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000355201908310994175232,`wxzf1567222470138100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.02,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.02元,`2498,`0.00000,`0.60%,`0.02,`0.00,`\r\n" + 
        		"`2019-08-31 14:33:11,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000355201908312127605424,`wxzf1567233182603100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.01,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.01元,`2498,`0.00000,`0.60%,`0.01,`0.00,`\r\n" + 
        		"`2019-08-31 09:26:48,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000355201908318150668308,`wxzf1567214797431100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.01,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.01元,`2498,`0.00000,`0.60%,`0.01,`0.00,`\r\n" + 
        		"`2019-08-31 11:10:00,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000355201908318150668308,`wxzf1567214797431100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000401422019083111580834021,`wxtk1567220999660160,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.01元,`2498,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"`2019-08-31 11:54:46,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000356201908313767623798,`wxzf1567223677847100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.03,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.03,`0.00,`\r\n" + 
        		"`2019-08-31 11:55:04,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000356201908313767623798,`wxzf1567223677847100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000601392019083111912792874,`wxtk1567223704432991,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 11:59:48,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000356201908314814484096,`wxzf1567223979557100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.03,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.03,`0.00,`\r\n" + 
        		"`2019-08-31 12:00:13,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000356201908314814484096,`wxzf1567223979557100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000001532019083111965360618,`wxtk1567224013645973,`0.03,`0.00,`ORIGINAL,`SUCCESS,`工号[2498]在手机订餐系统上订餐\\ 金额0.03元,`2498,`0.00000,`0.60%,`0.00,`0.03,`\r\n" + 
        		"`2019-08-31 15:39:09,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000356201908319794808202,`wxzf1567237066013100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000201482019083111943093536,`wxtk1567237148074548,`0.02,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.00,`0.02,`\r\n" + 
        		"`2019-08-31 15:37:55,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000356201908319794808202,`wxzf1567237066013100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.02,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.02,`0.00,`\r\n" + 
        		"`2019-08-31 15:34:55,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000358201908311105039288,`wxzf1567236887127100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`SUCCESS,`LQT,`CNY,`0.02,`0.00,`0,`0,`0.00,`0.00,`,`,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.02,`0.00,`\r\n" + 
        		"`2019-08-31 15:36:11,`wxb34ee6055a797702,`1451483202,`1518732391,`,`4200000358201908311105039288,`wxzf1567236887127100,`o8EPw0xouzBwiwWmRch5rN0CG7V8,`JSAPI,`REFUND,`LQT,`CNY,`0.00,`0.00,`50000001522019083111944045664,`wxtk1567236970372784,`0.01,`0.00,`ORIGINAL,`SUCCESS,`工号[2255]在手机订餐系统上订餐\\ 金额0.02元,`2255,`0.00000,`0.60%,`0.00,`0.01,`\r\n" + 
        		"总交易单数,应结订单总金额,退款总金额,充值券退款总金额,手续费总金额,订单总金额,申请退款总金额\r\n" + 
        		"`47,`0.69,`0.53,`0.00,`0.00000,`0.69,`0.53";
        List<Bill> bills = Bill.analyze(result,"2018-12-25");
        for(int i=0 ;i<bills.size();i++) {
        	System.out.println(bills.get(i).toString());
        }
        
    }

}
